home *** CD-ROM | disk | FTP | other *** search
/ Internet 53 / INTERNET53.iso / pc / software / windows / building / coldfusion studio evaluation / data1.cab / CFS_Wizards / CFML / DrillDown_Search.wml < prev    next >
Encoding:
Text File  |  1998-10-08  |  2.5 KB  |  73 lines
  1. <HTML><HEAD>
  2.     <TITLE>$${ApplicationName} - Search Form</TITLE>
  3. </HEAD><BODY bgcolor="ffffff">
  4.  
  5. <FONT size="+1">$${ApplicationName}</FONT> <BR>
  6. <FONT size="+2"><B>Search Form</B></FONT>
  7.  
  8. <!--- Search form --->
  9. <FORM action="$${SafeApplicationName}_Result.cfm" method="post">
  10.  
  11. <TABLE>
  12. <WIZSET i = 0>
  13. <WIZLOOP index="CurrentField" list="$${SearchFields}">
  14.     <WIZSET i = i + 1>
  15.     <!---- field is in format 'sTable.sField=sType;nSize;bRequired' ---->
  16.     <WIZSET Separator1Pos = Find( CurrentField, '.' )>
  17.     <WIZSET Separator2Pos = Find( CurrentField, '=' )>
  18.     <WIZSET Separator3Pos = Find( CurrentField, ';' )>
  19.     <WIZSET TableFieldName = Left( CurrentField, Separator2Pos - 1 )>
  20.     <WIZSET FieldName = Mid( CurrentField, Separator1Pos + 1, Separator2Pos - Separator1Pos - 1 )>
  21.     <WIZSET FieldType = Mid( CurrentField, Separator2Pos + 1, Separator3Pos - Separator2Pos - 1 )>
  22.  
  23.     <!--- Field: $${CurrentField} --->
  24.     <INPUT type="hidden" name="Crit$${i}_FieldName" value="$${TableFieldName}">
  25.     <WIZIF FieldType EQ 'DATETIME'><INPUT type="hidden" name="Crit$${i}_Value_date">
  26.     <WIZELSEIF FieldType EQ 'FLOAT'><INPUT type="hidden" name="Crit$${i}_Value_float">
  27.     <WIZELSEIF FieldType EQ 'INT'><INPUT type="hidden" name="Crit$${i}_Value_integer">
  28.     </WIZIF>
  29.     <INPUT type="hidden" name="Crit$${i}_FieldType" value="$${FieldType}">
  30.     <TR>
  31.     <TD>$${FieldName}</TD>
  32.     <TD><SELECT name="Crit$${i}_Operator">
  33.         <WIZIF FieldType EQ 'BIT'>
  34.             <OPTION value="EQUAL">is
  35.         <WIZELSEIF FieldType EQ 'CHAR' OR FieldType EQ 'MEMO'>
  36.             <OPTION value="CONTAINS">contains
  37.             <OPTION value="BEGINS_WITH">begins with
  38.             <OPTION value="ENDS_WITH">ends with
  39.             <OPTION value="EQUAL">is
  40.             <OPTION value="NOT_EQUAL">is not
  41.             <OPTION value="SMALLER_THAN">before
  42.             <OPTION value="GREATER_THAN">after
  43.         <WIZELSEIF FieldType  EQ 'INT' OR FieldType EQ 'FLOAT'>
  44.             <OPTION value="EQUAL">is
  45.             <OPTION value="NOT_EQUAL">is not
  46.             <OPTION value="GREATER_THAN">greater than
  47.             <OPTION value="SMALLER_THAN">smaller than
  48.         <WIZELSEIF FieldType EQ 'DATETIME'>
  49.             <OPTION value="GREATER_THAN">after
  50.             <OPTION value="SMALLER_THAN">before
  51.         </WIZIF>
  52.         </SELECT>
  53.     </TD>
  54.     <TD>
  55.     <WIZIF FieldType EQ 'BIT'>
  56.     <INPUT type="radio" name="Crit$${i}_Value" value="1" checked> Yes
  57.     <INPUT type="radio" name="Crit$${i}_Value" value="0"> No
  58.     <WIZELSE>
  59.     <INPUT type="text" name="Crit$${i}_Value">
  60.     <WIZIF FieldType EQ 'DATETIME'>(i.e. 12/31/97)</WIZIF>
  61.     </WIZIF>
  62.     </TD>
  63.     </TR>
  64.  
  65. </WIZLOOP>
  66. </TABLE>
  67. <P>
  68. <INPUT type="submit">
  69.  
  70. </FORM>
  71.  
  72. </BODY></HTML>
  73.